Electricity consumption 3E building

This data is obtained by a Fluksometer, installed in the technical room in the Kalkkaai 6 building, ground floor. This device measures the consumption of the entire 3E building with an error of maximum 5-10%. The processing is powered by OpenGrid (www.opengrid.be).



In [1]:

    
import pandas as pd
import charts
from opengrid.library import misc, houseprint









    



Server running in the folder /mnt/data/work/opengrid/code/og/notebooks at 127.0.0.1:37996



In [ ]:

    
hp = houseprint.Houseprint()



In [9]:

    
sensors = hp.search_sensors(key='565de0a7dc64d8370aa321491217b85f')

head = pd.Timestamp('20160101')
tail = pd.Timestamp('now')

df = hp.get_data(sensors=sensors, head=head, tail=tail)

Interactive plot of measurements since 1st of January 2016. Unit = Watt

Contains minute-values. Use the slider to zoom in/out.



In [10]:

    
charts.plot(df, stock=True, show='inline')









    Out[10]:









    
        
            565de0a7dc64d8370aa321491217b85f×

        
        
            
        
    

    
        
            
                Adjust chart settings
                
                    
                        
object {26}
colors [10]
symbols [5]
lang {18}
global {3}
chart {13}
title {4}
subtitle {3}
plotOptions {21}
labels {1}
legend {16}
loading {2}
tooltip {14}
credits {5}
navigator {11}
scrollbar {17}
rangeSelector {5}
navigation {4}
exporting {3}
width : auto
scale : 2
type : line
height : 400
series [1]
xAxis [1]
yAxis [1]
_stock : true

                    
                    
                        
                            
                        
                        
                            
                                
                                    
                                        
                                        .json

Total consumption of first quarter of 2016



In [22]:

    
total = df.ix[:'20160401'].sum()/60/1000 
print("Total consumption jan-feb-mar 2016 = {:.0f} kWh".format(total.values[0]))









    



Total consumption jan-feb-mar 2016 = 20740 kWh